from sqlalchemy import Column
from sqlalchemy.dialects.oracle import VARCHAR2, NUMBER
from app.db.base import Base

class HighSchool(Base):
    __tablename__ = "HIGH_SCHOOL"
    __table_args__ = {"schema": "IARO_EGATEWAY"}

    high_school_id = Column(NUMBER, primary_key=True)
    coop_hs_code = Column(VARCHAR2(50), nullable=False)
    hs_name      = Column(VARCHAR2(200), nullable=False)